-----------------drity read-------------------------
GO
IF OBJECT_ID('[dbo].[spProduct_CapnhatDonGia_ERROR_TH6]') IS NOT NULL

BEGIN 
    DROP PROC [dbo].spProduct_CapnhatDonGia_ERROR_TH6
END 

GO
create proc spProduct_CapnhatDonGia_ERROR_TH6
	@MA_SP VARCHAR(10),
	@DONGIA INT
as
	begin tran
		declare @value INT
		select  @value=s.DONGIA
		from SANPHAM s 
		where s.MA_SP=@MA_SP
		set @value=@DONGIA
		waitfor delay '00:00:10'
 		update SANPHAM set DONGIA=@value where MA_SP=@MA_SP
	commit
	
